Skip Headers

Oracle® Database Backup and Recovery Reference 10g Release 2 (10.2) Part Number B14194-03 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# RC_PROXY_COPY_SUMMARY

`RC_PROXY_COPY_SUMMARY` contains aggregate information about all available proxy copy backups for databases registered in the recovery catalog.

This view is primarily intended to be used internally by Enterprise Manager.

Column | Datatype | Description
--- | --- | ---
`DB_KEY` | `NUMBER` | The primary key for this database.
`DB_NAME` | `VARCHAR2(8)` | The `DB_NAME` of the database incarnation to which this record belongs.
`NUM_COPIES` | `NUMBER` | Number of copies created by all proxy copy operations for this database.
`NUM_DISTINCT_COPIES` | `NUMBER` | Number of distinct copies created by all proxy copy operations for this database.
`MIN_CHECKPOINT_CHANGE#` | `NUMBER` | Minimum checkpoint SCN among any proxy copies for this database.
`MAX_CHECKPOINT_CHANGE#` | `NUMBER` | Maximum checkpoint SCN among any proxy copies for this database.
`MIN_CHECKPOINT_TIME` | `DATE` | The oldest checkpoint time among any proxy copies for this database.
`MAX_CHECKPOINT_TIME` | `DATE` | The most recent checkpoint time among any proxy copies for this database.
`OUTPUT_BYTES` | `NUMBER` | Sum of sizes of all output files generated by proxy copies.
`OUTPUT_BYTES_DISPLAY` | `VARCHAR2(4000)` | Same value as `OUTPUT_BYTES`, but converted to a user-displayable format, for example `n`M, nG, nT, nP.